# encoding=gbkimport xlsxwriter
# 一：创建工作簿
# workbook = xlsxwriter.Workbook('test.xlsx')#创建一个excel文件
# 二：创建工作表
# worksheet1 = workbook.add_worksheet('test-sheet1')#在文件中创建一个名为test-sheet1的sheet,不加名字默认为sheet1
worksheet1.set_row(0,60) # 设置行宽
worksheet1.set_column(1,2,30)  # 设置列宽
worksheet1.set_column('D:F',40)
workbook.close()


